FAQs: Stock valuation report

This can be due to the following:

• If the current stock valuation report includes the value of both confirmed and unconfirmed stock items.

  This is because the retrospective valuation report only contains the value of confirmed stock items.

  This will occur if your current valuation report was produced using a version of Sage 200 prior to v2010. In earlier versions of Sage 200, the quantities of both confirmed and unconfirmed stock items were used to calculate the value of your stock.

• If you have revalued your stock, for stock items using the FIFO and Actual costing methods.

• If you have recorded stock items in your warehouse as sold before you have recorded the same stock items as received.

  This is because the current stock valuation report uses the last cost price of the item. If you subsequently record goods as received using a different cost price, the last cost price is updated. When you produce the report retrospectively, the newer cost price is used to calculate the value of your stock.

  Example

  You have 20 of tins of paint in your warehouse, but you have not recorded the receipt. Your records in Sage 200 show you currently have no stock. The last cost price of the stock was £1. The current stock valuation, therefore, is £0.

  1. 15/07 - you sell 10 tins. The current stock valuation report shows you have -10 in stock at a value of -£10. This is because the last cost price was £1.

  2. On 30/08, you produce a stock valuation report retrospectively for the 15/07. This shows your stock level as -10 with a value of -£20.

  3. 18/07 - you record the receipt and the invoice for 20 tins of paint. The cost price is £2. The current stock valuation report shows you have stock level of 10 with a value of £20.

     		Stock movement	Cost Price	Stock level	Stock Value
     30/07			1	0	0
     15/07	Out - SOP	- 10	1	- 10	-10
     18/07	In - POP	+20	2	10	30

     The retrospective stock valuation run hon 18/07 with a valuation date of 15/07 would show a stock level of -10 but a stock value of -20, as the last cost price was updated to £2.

• If the standard cost price on a stock item is changed more than once in the same day, and the current valuation report was produced before the final price change.

  Example

  The standard cost of a box of wine is £10. A current stock valuation report is produced. The stock is valued at £10 per box. Later that day the standard cost of the item is changed to £12.

  When a retrospective stock valuation report is produced for the same day, the stock is valued at £12 per box.

• If transactions have been backdated.

  Example

  You have 100 chairs in stock. They use a FIFO costing method.

  1. 30/07 - You produce a current valuation report. This shows a stock level of 100 chairs.
  2. 01/08 - You record the despatch of 10 chairs, dated 28/07.
  3. 01/08 - you produce another current valuation report. This shows a stock level of 90 chairs.

  4. 01/08 - you produce a retrospective report with a valuation date of 30/07. This shows a stock level of 90 chairs.

     The retrospective report includes the 10 chairs that were issued because the transaction date is prior to the Valuation date for the report.

• If you have chosen to Update stock quantities when the invoice is posted in the SOP settings Order Processing tab.

  This affects the valuation report in the same way as backdating transactions.

This can be due to the following:

• The stock item has stock level of zero for the date specified on the report. Stock items with a level of zero are excluded from the report.

• The stock item has no cost or transaction history for the valuation date specified for the report.

  If this is the case the following message is printed at the end of the report: Stock items will be excluded from this report if no cost or transaction history is available for the selected date.

  This occurs if you have backdated your transactions or have deleted the archived stock history for that item.

  See an example

  Sage 200 uses the current system date to record changes made to the standard and average cost prices of stock items. If you run a retrospective stock valuation report with valuation date prior to the current system date, Sage 200 does not have any record of the cost price for the stock item. In the following example the current system date is 30/07.

  • 30/07 - You create a new stock item.
  • 30/07 - You enter a purchase order for the item at dated 01/07.
  • 30/07 - You record the receipt of the goods dated 05/07.
  • 30/07 - You run a current valuation report (As a t 30/07). This shows the quantity and value of the stock.
  • 30/07 - You run a retrospective stock valuation) report with a valuation date of 15/07. The stock item does not appear on the report.

  This is because the cost price of the item was recorded on the 30/07 and Sage 200 has no record of a cost price prior to this.

• The retrospective stock valuation report will be different to a current stock valuation report run for the same date.

  See an example

  This example shows how the stock level is affected when transactions are backdated:

  You have 100 chairs in stock.

  1. 30/07 - You produce a current valuation report. This shows a stock level of 100 chairs.
  2. 01/08 - You record the despatch of 10 chairs, dated 28/07.
  3. 01/08 - you produce another current valuation report. This shows a stock level of 90 chairs.

  4. 01/08 - you produce a retrospective report with a valuation date of 30/07. This shows a stock level of 90 chairs. This is not the same as the current valuation report run in step 1 because you have added a back dated transaction.

     The retrospective report includes the 10 chairs that were issued because the transaction date is prior to the Valuation date for the report.

• Stock items may not appear on the report or may be valued using a cost price different to that expected.

  Changes to the average and standard cost price of items are recorded by Sage 200 using the current system date, not the transaction date.

  If you run a retrospective stock valuation report for a date before the change to the cost price was recorded (the system date that the transactions was entered), the previous cost price of the item will be used. If no cost price was recorded , the item will not appear on the report.

  See an example

  Sage 200 uses the current system date to record changes made to the standard and average cost prices of stock items. If you run a retrospective stock valuation report with valuation date prior to the current system date, Sage 200 does not have any record of the cost price for the stock item:

  • 30/07 - You create a new stock item.
  • 30/07 - You enter a purchase order for the item at dated 01/07.
  • 30/07 - You record the receipt of the goods dated 05/07.
  • 30/07 - You run a current valuation report (as at 30/07). This shows the quantity and value of the stock.
  • 30/07 - You run a retrospective stock valuation report with a valuation date of 15/07. The stock item does not appear on the report.

  This is because the cost price of the item was recorded on the 30/07 and Sage 200 has no record of a cost price prior to this.

This is because prior to Sage 200 v2010, there was no history of the changes to standard and average cost of a stock item.

When you first upgrade to Sage 200 v2010, your standard and average cost history will be updated with your stock item's current standard and average cost prices. Any subsequent changes to the standard and average cost prices of your stock items, will be recorded. This allows you use a retrospective stock valuation report for your stock items that use the standard and average costing methods after the date you upgrade to Sage 200 v2010.

Note: Changes to the standard cost price of stock items are recorded using the current date on your PC.